Creating conditional running totals

There may be times when you have a list of ungrouped values, and you only want to subtotal some of the values in the list. For example:

• you have a list that contains both Canadian and U.S. customers
• you want to keep customer records sorted alphabetically based on customer name
• you do not want to break the data into groups based on the country
• you want a total of the values from just the Canadian records
• you also want a total of the values from just the U.S. records.

To accomplish this, create two running totals, one to keep a running total of the U.S. records, and one to keep a running total of the Canadian records.

• USTotal
  Maintains a running total of the U.S. records.
• CanadaTotal
  Maintains a running total of the Canadian records.